US President Donald Trump's National Security Advisor Mike Waltz is to leave his post following a scandal in which a journalist was accidentally included on a chat between officials about air strikes on Yemen, US media reported.