A busy street along a major commuter route into Birmingham was left looking 'like a river' after a burst water main caused flood chaos.