One of BBC Scotland’s most senior figures is standing down