The former Brentford manager was hired by Daniel Levy to take over from the ex-Celtic gaffer in North London