Sheffield councillor says government is “asleep at the wheel” over extreme heat