Yemen deserves hope and dignity, Security Council hears