The cold mains pressure water is flowing back up the hot pipe, through the hotwater tank into the coldwater storage tank which is overflowing out of the warning pipe. Regardless of whether you wish to fill a paddling pool or not, you should get non return valves fitted to your kitchen tap...