The USGS Water Resources web site has links to data, programs and information you might be interested in.
The EPA STORET website can also provide water quality and biological monitoring data.