I'm not really sure what you're getting at. Like others have said, “Water can’t be free anywhere” seems to be inevitable at a commercial level--but dystopian on an individual level. If you had neighbors in your rural area aggressively pumping water out of the ground your well would dry up...and you'd be paying "market price" for it.

Just looking at water usage when I owned a house, irrigation uses a ridiculous amount of water relative to everything else individuals use to live--including laundry, bathing, dishes, etc. If memory serves, sewage costs are significantly more than the water itself (and sewage as metered off of water consumption--so you're likely paying sewage feeds on water you're irrigating with).

The actual cost of enough clean drinking water for people is very small. Enough that drinking fountains are common and people shouldn't need to ration drinking water.