What produces the sound made by house plumbing when water runs?

My house is less than 10 years old, so it's not a rattling noise. When someone takes a shower, it's a sound that is similar to a waterfall mixed with a humming motor. No an annoying sound, just something I was curious about.