Texas secretary of state resigns after leading botched voter purge that questioned the citizenship of almost 100,000 people