The public sector in Scotland is being urged to step up its efforts to tackle the climate emergency, after a survey revealed that most government bodies have done little or nothing in response.