A busy road reopens after water from a burst pipe froze over the highway causing traffic chaos and affecting supplies to thousands.