Not A Drop

Some researchers looked at what happens to California in an extended drought situation.

tl;dr: water gets expensive, lawns disappear, agriculture changes, central valley towns empty out, but the state survives.