Just double-checked for pulley movement, now I'm seeing quite a bit of movement out of the water pump pulley. Tightened bolts on top, still saw the movement - could a bad bearing be the cause? Seems like that could produce that noise, right?
Just to follow up, that was the culprit! The internal fins had started to grind, hence the noise. Replaced the whole pump.