O'Neill transformed Celtic when he was appointed Hoops boss in 2000