A man suspected of attacking two women with a crossbow in Leeds died as a result of a "self-inflicted gunshot wound" to the head, an inquest has heard.