I'd suggest separating those topics into water and sewer (while the flows are generally much larger, the design of stormwater conveyance is very close to wastewater collection). Water distribution hydraulics is obviously much more complicated than gravity flow situations...I think Haested Methods used to have a good book on water distribution. All of the books previously mentioned are good.
If i had to narrow it to three, I'd say the M&E wastewater collection and pumping, any undergraduate level hydraulics book, and I think Haested methods has a book for water distribution design. It's tough to narrow it though.
As cvg mentioned, Chow and B&K are both classic hydraulic texts, but real world examples aren't their intent.