'You don’t have to look too much farther than Calgary to see the hell that they lived in this last summer with dealing with the water main breaks,' said Banff Mayor Corrie DiManno