The notorious nightclub in London where Prince Harry and Prince William used to party in their youth is set to reopen.