I imagine some cultures might resist moving away from where they could see the Moon. The omnipresent Moon might become a sort of god to those that lived under it, such that they would fear traveling so far away from it that it left. Maybe others would fear the perpetually darker nights.
This seems like it could be the premise of a science fiction story, perhaps similar to Asimov's Nightfall.
A geostationary moon, if tidally locked to present the same face to the earth all the time, would certainly be a convenient termination point for a space elevator. So rather than a space elevator dumping you off in space, you'd be dropped off on the moon. Of course some genius will start transferring the earth's biosphere, oxygen, carbon, etc to the moon and just dumping it there to terraform it. Obviously (?) you can't just run a garden hose to the moon and suck on the moon end and expect a flow rate, although it is sci-fi so maybe if you pressurized the earth side up to something approximately ridiculous, you'd be able to squirt water across to the geosync moon. I would not want to be in charge of that project...
The area of deflection would likely be very large and gravity would still be normal to the surface of the water, so no, you probably wouldn't be able to tell. You might perhaps notice the horizon being closer.
</boring>
Anything farther away is falling "up" and anything closer is falling "down". So the water would fall "down" (i.e. toward the moon).
But since there is plenty of gravity on earth this would mean the water is effectively just lighter. And water on the other side of the Earth is heaver, and would flow to the lighter area until the lighter side was tall enough (i.e. had enough extra water) to balance that out.
I wonder how that would effect rocket launches? Would it be better to launch on the far side of earth or the moon side?