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...