John Rood resigns at request of US president, the latest official to be purged following impeachment trial