Security Council debates resolution admitting 'Palestine' as a full member state as US announces its opposition to the measure.