Cars have been left submerged while residents have had to be evacuated from their flooded homes