Water has to flow. It doesn’t just appear where it “needs” to be.

There’s a brackish pond/lake in a park in Victoria BC, you go over a bridge from downtown to get to the main entrance, though the locals can cross a street.

If should actually be a bay, but under said bridge is a stone formation that forms the throat of this bay, which being so long and narrow, cannot fill up or drain as fast as the tides. So at high tide there is a waterfall flowing into the pond, and as the tides recede it’s a waterfall going the other direction.