He could be the longest-serving councillor in the country but now he has decided to hang up his boots