A city centre has been flooded and thousands of properties have been hit by water supply problems after a main burst.