County chiefs have been urged to stop using “probable carcinogen” glyphosate in public spaces.