The leader of the opposition Syrian National Council, Ahmed Moaz al-Khatib, has resigned, he says in a statement on his Facebook page.