His gruesome crimes were a basis for ‘Silence of the Lambs.’ The sister of one of his victims has mixed feelings about his execution