CNN named a new CEO, ending months of leadership drama