I grew up by the sea. We used to drink tap water (groundwater pumped from the village), but now tap water is taken from the city. Let me tell you, fresh water can be produced by the sea (on the beach) and it is very sweet. When I was a child, when I was playing at the seaside, I always went to the pressure well by the sea to drink water. Something like this: