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).
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.