Around 40,000 households in north Wales face having no water as five schools have been forced to temporarily shut their doors after a pipe burst at a treatment plant.