Elon Musk said he will resign as CEO of Twitter as soon as he finds someone else to lead the social media giant.