The UN Security Council is demanding access to Syria for its humanitarian chief, as rebels withdraw from their stronghold in Homs.