The former Spurs captain will be at the club’s Champions League game next Tuesday to say goodbye to the fans