One man has died and another is under police guard after a rooftop stand-off with police in northern NSW.