Palestine has been approved membership of the UN cultural agency Unesco, defying calls from US and Israel not to allow it.