Given that there's numerous cities and countries that are suffering from water shortages, you'd think that the price of water would go up already. But it hasn't, because there's interests at play to keep the price of water relatively low.
Anyway you'd need different prices for different types of consumers, because it's a basic need for humans; you can't make water unaffordable for poorer people.
I'm all for increasing the price of water and electricity for big consumers though, so that they will invest more R&D into reducing their consumption. Because when it's cheap, they'll just use more of it without thinking. That's also why coal power was (is?) a thing for so long.