Hi!
I've experience using Haestad Method's Water Cad Water Distribution System Modeling Software. This is a powerfull tool where you can handle varios numbers of scenarios. You can model pumping systems, deep well connected to a distribution system, etc. If you compare between Water Cad and EPA Net there is only a big reason to choose between software: the price. EPA Net is for free and you can download from EPA website. Water Cad Licenses cost varies in function of the number of pipes you want.
If you have any question, feel free to e-mail me at asoto@csagroup.com