People told to avoid Stourbridge neighbourhood hit by floods described as a 'swimming pool' following severe weather