Brooks Macdonald has appointed Andrew Shepherd as group chief executive officer, succeeding Caroline Connellan who is leaving for Standard Life Aberdeen.