I bought a house in California, and the docs include a bunch of details on potential disasters, natural and otherwise. Dam inundation maps are engrossing - there's a dam over San Leandro that could put water on the OAK runways.

That said, I see wiggle room on "if nothing changes there eventually won't be enough water", even if we all know that in practice nothing will change in time, so I don't know how that actually plays out.