Investigators confirmed Tuesday there were eight victims, including four children, and that the suspect had suffered a self-inflicted gunshot wound and later died