CNN's Anderson Cooper said to have royal links through his great-aunt, who had an affair with Prince Harry's great-great uncle