Sheffield City Council has issued a statement amid a “wildlife emergency” at a top tourist attraction hit by low water.