The unnamed border agent was shot in the neck and died. One suspect was killed, according to a local news report