Move forcefully opposed by most countries, except for Israel and Gulf, and expected to be ignored by rest of Security Council, which could undermine credibility of world body