TUrns out, it's NOT the water pump tensioner. I removed the belt, and the sound persists. I guess it's time to break down and take it to a mechanic. I bet it's something bad and expensive internally :-/