The Security Council has voted unanimously to end the UN peacekeeping mission in Haiti in mid-October after more than 20 years.