Thanks again for the reply, Jim. Putting out fires everywhere for me.
The coolant hose was probably disconnected during the tip rebuild.
I will move the worm clamp a bit closer to the pump tomorrow but I don't think that's where the leak is. There was no water around the connection when I felt around today. It is coming from somewhere high up.
As you suggested, it could be a pump bearing leak, or maybe a bad pump gasket and then water somehow just trickles down - this would have been much cheaper to fix, I suppose.
I actually already removed the firewall and everything looks bone dry from there. I will take another look tomorrow.
I have replaced water pumps on my Mazda before. I am hoping I can do this one DIY, too. Though the space around the pump looks pretty tight. I hope the engine doesn't need to be lowered to replace the water pump...