Meta's leader of cryptocurrency efforts says he will be leaving the firm at the end of the year to follow his "entrepreneurial DNA".