Like other resource misallocations, this would be a non-issue if water were priced at market rates.
Residential use (outside of public works) is typically trivial, so could stay with its existing model.
Industrial use in contrast is much different so is a more interesting thing to model.