the water pump just takes over the water supply from the main source (the holding tank) and doesn't feed the hot water tank directly but feeds the entire RV instead of the "city water supply".
https://www.camperguide.org/rv-plumbing-diagram/
If your water pump is leaking you may need to replace the pump. Do you get cold water out of the faucets when you run the pump? Does it leak at the hose fitting or actually at the pump?
Does it leak when you are hooked up to city water because that's the end that would be on the city water pressure side? Do you use a pressure regulator when you hook up to city water?
__________________