Some communities have their own wells and filtration systems. They can be better. Also many homes have their own wells. You can have the well tested -- for both volume and quality -- before you buy. If necessary, you either drill deeper sometimes and again you can always install filtration.
I'm lucky. I filter very fine sand out of my well water with a cheap filter and it tastes great and is perfectly drinkable.