Old saying in the West: "Whisky's fer drinkin', water's fer fightin' over." Mismanagement of water resources is hardly a new thing.
A good resource book for California is Dorothy Green's "Managing Water – Avoiding Crisis in California", published 2007. She tends to put a brave face on the prospects, but gives good insight into many aspects of the situation.