Water main break causes major flooding