Reddit reviews Fluid Mechanics

Water Resources Engineering - Larry W. Mays or Applied Hydrology - Te Chow for engineering hydrology. They are somewhat outdated in not including some new methods (like ML methods) but both solid for the fundamentals. There is also a PDF copy of the latter floating around if you do a google search.

Chow's Open-Channel Hydraulics book is also great (for channel and hydraulic structures design, non-pressurized), but mind numbing to go through. Also, Fluid Mechanics - Frank White for general fluid mechanics overview.

Finally, although I've not personally read/used it, HEC-22 is a design manual for urban drainage systems and Advanced Water Distribution Modeling and Management for modeling/design of water distribution systems.