The pipe on the left that you have marked cold is the feed from the cold tank in the loft to the hot water cylinder. If you turn the red gate valve off this shut off your hot supply. However, gate valves can often seize up or pass water so you may have to turn the cold supply off to the tank and...