Coming back from our summer house at the moment. There we have a underground well from which the water is brought through pipes about 100m into the house. Height difference makes the water running without pumps. It's excellent quality, naturally filtered through sand. Always cool from the tap and not a hint of chlorine, or anything else. No need for bottled water when staying there. I should maybe bring some back to town next time.
The only downside is on dry summers, when you have to conserve water usage to drinking and cooking. But we have water for all other use from the lake as well, so it's no real problem.
cheers porphy