The former Real Madrid and Bayer Leverkusen boss will succeed Liam Rosenior as manager in the aftermath of the FA Cup final loss to Man City