The market is very good at ignoring or hiding scarcity or other externalities until the damage is done. Nothing is "automatic" about it. The "free market" doesn't exist in a way that would allow the price to organically reflect water's actual scarcity.