Arc Hydro
The book
I have "Arc Hydro, GIS for Water Resources" dated 2002 edited by David R. Maidment. It is for surface water.
Now there's a newer book "Arc Hydro for Ground Water", 2011 but I don't have that one. Aquifers, wells, and subsurface water.
Where to get the software
The book came with a CDROM but it's old. Instead of even looking at it, download the correct version of Arc Hydro for your version of ArcGIS Desktop from http://downloads.esri.com/archydro/archydro/
Do I want the 32-bit or 64-bit version? I installed 64-bit "Background Geoprocessing" so I am trying 64-bit first.
Resources
ESRI Hydrology community page http://resources.arcgis.com/en/communities/hydro/
Arc Hydro for Ground Water wiki: http://archydrogw.com/Main_Page
GIS For Water Resources: http://www.esri.com/industries/water_resources/