I was just reading a request for fly fishing information from an out of the country angler who was visiting the USA and looking for instruction , bodies of water, and a fishing buddy.

I went to "Mapquest" and could see rivers, lakes ,and streams - but none were identified, except for an occasional pond. The only other site that has water tables is the state-by-state USGS streamflow data ; since i live in NY it is :
<< [url=http://waterdata.usgs.gov/ny/nwis/rt:8ec3c]http://waterdata.usgs.gov/ny/nwis/rt[/url:8ec3c] >>
(but you can personalize the data by cut and paste, and submit your own states abbreviation by eliminating the"ny" and add your state)

Is there any online site or resource which identifies bodies of water ?

Dadflyer

Tight lines
Bright fish
Taut threads