CNN President resigns following leak of his relationship with CNN employee