A Yemeni man working on security issues with the US embassy in the capital Sanaa has been killed in a drive-by shooting, officials say.