Head of Secret Service resigns after attempted assassination of Trump