Police said that Anthony Nephew, 46, had died of what appeared to be a self-inflicted gunshot wound, after fatally shooting members of his family