Water supplies have been fully restored five days after a burst mains left 40,000 homes across north Wales without water.