Engineers are completing repairs to a burst water main which left households and businesses experiencing supply issues overnight.