Just playing with ideas...
So, if we leave Guild city where it is right now, that has it way inland and not near any rivers, lakes, seas, or oceans.
But... maybe it is some sort of weird karst environment and there are all sorts of nice underground lakes and rivers and such.
And maybe in the midst of the city is a giant sink hole down to a big lake