You make some very qualifying statements.... Would you like to provide evidence that farmers pay too little for water? That they use too much water? And what is this gigantic portion of water consumption that you are referring to? I mean, they do kind of need to use water to grow their respective foods... sooooo I guess I wonder what world you expect to live in where farmers don't use more water than the average person?
"Agriculture accounts for 80% of water consumption in California, for example, but only 2% of economic activity. Farmers flood the land to grow rice, alfalfa and other thirsty crops. By one account, over the years they have paid just 15% of the capital costs of the federal system that delivers much of their irrigation water."
Trying to grow rice in California is as ludicrous as the Saudi plans to grow wheat in the desert with oil-desalinated water. I appreciate this is a bad situation for the farmers and in an ideal world the climate change mitigation fund would compensate them for stopping.
The market is not the best way to distribute water if the people in those are willing but cannot pay.
The agriculture vs. residential vs. industrial policy/pricing debate is more about how to split water between entities connected to the big state-run aqueduct system, e.g. Central Valley agriculture vs. LA/SF. Which is also important, but a different situation from this one.
I would expect that if this persists, a commercial water delivery industry will spring up in the area. Of course, either way, you are very motivated to use much less water than you would if your well worked for actually free.