Manchester United legend Roy Keane didn't enjoy success in management but has since become a household name in the media world