I grew up on wells. Most had hard water (calcium/iron) with various flow rates. The area I spent most time finally installed water lines when too many people had problems with their wells (quality and volume) so that is a large area where homes over 20 years old will have access to a well (or multiple wells) and public water.
The last place I lived had an awful well, very hard with a bad taste. It was a rental and I never had it tested, but I avoided using it for drinking or cooking. I did use it to wash and for the barn.
My current property has an excellent, artesian well. Sweet, soft spring water and the overflow from the well fills my water trough for the pasture - I estimate around 900 gallons a day goes through that overflow and trough which I can use (and have used) as an emergency water supply. Also, with the constant supply of ground water my trough doesnāt freeze even in extreme cold.