Edit: Santiago in Chile seems to be close to such a case. Interestingly, 70% of the population want to see a return to public ownership of water rights. And it's pretty hard to find evidence having private ownership of water rights is helping ensure long term supply for all.
Increasing the price causes demand to drop. Increasing it so the demand matches the supply means no shortage.
Water usage is just as elastic as any other consumption behavior. Heck, I halved mine this year by simply selectively letting parts of my yard dry up in this hot summer. And enterprises can pass increased prices on to the final product.
Some rich people didn't want their lawns to go brown, so an entrepreneur rented some tanker trucks, filled them up outside the region, drove back to Seattle, and watered their lawns.
This caused a hue and cry about how unfair this was, and another ordinance was passed to make it illegal to truck water in.
However, it is exactly what you asked for - an example of the free market delivering when the price is high enough.
As for biological needs, I recommend reading "Empire of the Summer Moon" about how the Comanche were able able to survive in the desert. This included killing their horses and drinking the contents of their stomachs as an example of how far they would go to get water.
Besides, biological drinking water is only a tiny, tiny fraction of human water consumption.
Another example, when there are natural disasters, entrepreneurs would truck in bottled water and gasoline and sell it (until the government put a stop to that, too).
Some businesses die but the others adapt and find solutions. It’s where human creativity and innovation shines. An expensive item is a great motivator to find alternatives.
Unless OP is just using hyperbole to make a point, in which case maybe they shouldn't.
You must have heard about the fires in California in the last few years, right? Look up what's happened to air quality on the west coast from the smoke.
Also, be honest about how we're rapidly barreling toward the end of economic growth because the weather keeps destroying industrial and agricultural production.