Hours of torrential rain in Sheffield and northern England leaves roads completely flooded