The UN envoy for Yemen has told the Security Council that the number of air attacks by the Saudi-led coalition has dropped dramatically in the past two weeks.