huge water leak next to distributer where lower rad hose goes in on 2004 Nissan Xterra

i have a major leak where the lower radiator hose goes into the intake manifold. it looks like a small tube to the right of where thermostat housing is just left of distributer. the tube is about a little over an inch in diameter from what i can see, water poors out of it when i fill the radiator and as soon as the radiator cap put on it stops until engine warm and then overheats and poors out

Asked by for the 2004 Nissan Xterra