No. There’s an extremely simple way to solve this problem that would work; Everyone pays the same price for water. If the government is not going to do that then blame the government.
It's also worth noting that water probably doesn't need to be very expensive before usage starts getting curbed quite heavily by the main consumers. If there's no price, might as well use as much as you're allocated - there is no direct consequence for doing so.
E.g., tomato farming produces around $4000 worth of produce per acre and year[0], and requires 2.5 feet applied water. ($4000/acre)/(2.5 feet) = 0.5 cents/gallon. If the water got that expensive they'd need to stop growing tomatoes, since just the water would already cost more than the produce would be worth.
By contrast, residential water is 0.7 cents per gallon[1], so the prices involved are really tiny compared to what human users are already paying.
[0] https://www.nass.usda.gov/Quick_Stats/Ag_Overview/stateOverv...
[1] https://www.calwater.com/docs/rates/rates_tariffs/ela/202201...
I agree that the prices would not be exactly the same, my point is just that these prices are still extremely low. You don't need to fear people dying from dehydration (like the comment above suggested).
The flip side of this is that it never was profitable to begin with and only was done because citizens gave enormous handouts to these companies (paying for all their water). You can keep doing that, but make it more explicit: Make them pay for all the water, but give them a subsidy of $X and change it if they waste water.
Places that do charge for water (places like Perth, Western Australia) charge a few dollars per thousand litres - enough for several months of drinking water. Nobody is going to die from dehydration.