If the pipes are PVC waste lines, you will hear the water. You can wrap them in insulation to dampen the sound transmission.

I don't worry about the sounds in my studio. I can't or else I'd never get a single thing done. Between the dogs barking, the trucks on the road 100 yards away, the occasional airplane, and the lawn maintenance guys with their weed whackers and leaf blowers...... More than one time I have been tracking my acoustic guitars or vocals and here they come...... time to take a break for the 20 minutes or so it takes them to do their job.

remember, the only time the ambient sound is a problem is when you are recording anything with a mic. Aside from that, everything else in "in the box" in most studios, BB/RB. midi, etc....

The sound treatment in most studios is not about making it as quiet as possible, although that is a nice thing, it's about making the room a flat response room for the purpose of accurate monitoring for mixing and mastering purposes.

You can find my music at:
www.herbhartley.com
Add nothing that adds nothing to the music.
You can make excuses or you can make progress but not both.

The magic you are looking for is in the work you are avoiding.