Cardiff Council said it deliberately lowered the water level at Roath Park Lake so it could carry out essential works