I live in the countryside in Ohio. We have a well and a water softener. But my kitchen sink has a second faucet that goes directly to the well, bypassing the softener - I always drink from that one because it tastes better.
I fill up my Nalgene before I leave and only buy bottled water on rare occasions.
I used to live in San Mateo, they had pretty good tap water to.