A burst water pipe in Elgin is causing disruption, leaving some residents without water and prompting urgent roadworks.