As hinted at by several replies, fresh water reservoirs are accumulated rain water which trickles down from the surface.
Below this fresh water zone the pore water is almost always brine, often referred to as connate water. This is sea water trapped with the sediments when the rock is formed.
At the sea shore contiguous high permeable sand bodies can be subject to competition between the surface rain accumulations and the salty sea encroachment due to various gradients of elevation, density, temperature, chemical concentration, etc. as wells as capillary forces/surface tensions.