Twitter owner and CEO Elon Musk is searching for a new CEO of the company, sources told CNBC's David Faber.