A senior Secret Service agent who was being investigated by the government for failing to disclose a long-standing relationship with a foreign citizen killed himself last week