Twitter CEO Elon Musk on Thursday announced that the company will welcome a new female CEO in June. He will still oversee major functions of Twitter and hold an executive role.