NSC head will leave position at end of August; PM Bennett thanks Netanyahu appointee for 'many years of contributing to Israel's security in a professional and successful manner'