I would think the water pump would be a lot further doen the shaft. would be surprised if you would hear it.

Hard to say what it is but sounds to me like a bad bearing somewhere.Really just another guess though.

Hope its simple and you get off easy.