US Secret Service director resigns after Trump assassination bid