The (obvious) effect of increasing water prices over the medium and long term would be the displacement of water hungry crops such as almonds and rice, as it would no longer be economical to farm them in California. The equilibrium level of water consumption would be much lower as a result.
Then people in other places grow food instead. It's a slow change, but it's certainly elastic.
Agricultural subsidies are common and significant, especially in rich developed nations. This is for various reasons, but it does have some significant knockdown effects such as exasperating third world poverty. There are numerous complaints brought to the UN, the WTO, by various poor nations but they are generally ignored or swept under the rug.