I heard about a couple articles that summarize a study on US watersheds

11 Cities May Completely Run Out Of Water Sooner Than You Think - (discuses the major cities at most risk)

Nearly One In 10 U.S. Watersheds Is 'Stressed'; Demand For Water Outpacing Supply - (more just general highlights)

(Map indicating how stressed a watershed is to produce supply amount demanded)