The Tesla billionaire said in a tweet that his role will transition to being Twitter’s executive chairman and chief technology officer