Pedro Gonzales died of an apparent self-inflicted gunshot wound after shootings in New Caney, Pasadena and Houston