The former Sunderland, Middlesbrough and Celtic boss wants to return to management in the new year