The former Celtic and Middesbrough boss replaces Craig Levein, who had presided over a disastrous start to the Scot's 2014 World Cup qualifying campaign in his three-year spell