One of the UK's biggest theme parks has been forced to close in the middle of school summer holidays due to a burst water main in the area.