Depends on the area.

I live in iowa - nearly everyone is on rural water because wells don't produce much water. I'm on a well and I can't water my lawn - after an hour my well is empty. My well is about a meter in diameter so that should be a lot stored. it would be $20k to extend the city water pipe to my lot.

i used to live in MN, there I knew farmers on a 5cm well who had no problem watering lawns, and 50 cows from the well.

in colorado where this story is water is less available than iowa. (most farms have a year round creek that could be treated to become drinkable)

That’s one of the real solutions - we shouldn’t be using potable water for everything. Houses that are plumbed on city water should have two water sources - potable and other.

that won't help much. Water costs are mostly not in the treatment in general. pipes and pumps are the larger costs for most.