From the Natural Resources Defense Council, a useful national map and state by state details about water. See Ready or Not: How Water-Ready is Your State? April 8, 2012. From the report:
As climate change affects communities across the U.S., some states are leading the way in preparing for the impacts on water resources. These states are reducing carbon pollution and planning for climate change impacts. Yet many states are not acting and remain woefully unprepared.
Click on a state to find out what risks communities there may face and what the state is doing to prepare.
In a related newsclip, see this HuffPost article about the state of CA, which it says has done the most planning and should be in the best shape. April 8, 2012.
One more report re Sustainable Water and Environmental Management in CA was recently issued by the National Academy of Sciences.
Recovery Diva 
I estimate that up to 40% of all Public Assistance monies under the Robert T. Stafford Act distributed in flood related Presidentially declared disasters and emergencies goes to fund repair or replacement of local government water and sewer systems. EPA builds them and FEMA rebuilds them.