Campbell, who has headed the council since reorganisation, said Aberdeenshire’s recent Best Value report, which praised the authority for its financial controls and clear ambitions, had been “an important factor” in his decision to leave.

“I am very satisfied with the findings of the report, which demonstrate that I will be leaving Aberdeenshire Council in a very good position, with sound financial management, a clear vision for the future and a committed and motivated workforce,” he said

“It would be easy for me to stay here for another four years until retirement, in a position where I am very happy and confident about the direction the council will take.

“However, I think that now the time is right to hand over the reins for someone else to continue to deliver our vision to make Aberdeenshire Council the best in Scotland. I am keen to take on new challenges. I am passionate about the delivery of excellent public service delivery and feel that there will be new opportunities for me.”

Council leader Anne Robertson said Campbell would leave Aberdeenshire “in the best shape it has been in since its creation”. “He has worked tirelessly to deliver the quality services to our residents and has always led from the front with complete dedication and professionalism,” she said.

Although the council has attracted controversy over the Trump affair, a senior local government source said Campbell’s decision to leave was more akin to a “pre-planned early retirement” than a resignation. “Alan hits 62 in December so he’s got his forty years in the bag,” he said.

The council is now hunting for a replacement for Campbell, who is due to leave his post in October. He is the second north-east chief executive to step down in as many months, following the decision of Aberdeen City chief Douglas Paterson in May to take early retirement.