President Biden's press secretary Jen Psaki is planning to depart the White House to take an on-air role at MSNBC, a source familiar with the matter told CNBC.