Missile hits near entrance to hospital in northwest Yemen, killing hospital staff, children and a guard, aid group says.