Irish Water plans to cut off water to large areas of Cork city overnight on Tuesday to repair a critical mains pipe at risk of bursting.