Pictures and video: Chaos in north-east as torrential rain causes flooding