Possibly Revit, AutoCAD MEP or CADmep. Revit has some engineering tools. I assume the others do as well. I have used all of them but only to model systems that were already engineered. They are all quite pricey.
There are others I have seen but not used such as CADPIPE, and other more specialized ones like HydraCAD and AutoSPRINK for fire protection, etc, but I assume you are looking for something a bit more generic.
Are you an engineer looking for some automation? If you are not and are looking for software to engineer the systems for you that seems a bit risky.
Assuming you are not an engineer, residential and light commercial requirements are pretty easy. You could check the local codes and size them yourself and have the models checked out by your plumber or engineer.
