I get a very high pitched screaming noise from one of my taps (cold) in my bathroom whenever its turned on. Its quite loud and makes a good job of going through walls!
It only seems to happen when a half decent amount of water is flowing i.e. you can't hear it when there's just a dribble...