At the age of 34, Stephen Moir is already head of HR for a county council, as well as president of his profession’s association. But, preferring to keep a healthy work-life balance, he has no ambitions to be a chief executive, he tells Michael Burton