My Florida neighborhood used to be based on wells and septic tanks. Wells have to be at least 75 feet from on-site waste treatment areas by law.
The county ran water lines into the neighborhood about 20 years ago.
I drank well water until about 10 years ago. I stopped because the water was too hard. It now has too much iron taste as well.
We have "ag" water for crops and "culinary" water (filtered, chlorinated) as "potable". Ag water flows in canals. Culinary water arrives treated and pressurized in city water lines. I use an RO unit under the sink for all drinking water. It gets a second cleaning via the refrigerator filter. That removes toxic metals, VOC and micro-organisms. Nothing is perfect. Even the RO has somewhat higher mineral content that requires periodic descaling of the coffee maker.