A long-serving staffer with the UN World Food Programme (WFP) has been shot and killed in Yemen.