The Security Council has agreed to end the UN military observer mission in Syria in the face of an escalating civil war.