A US secret service agent is under investigation for attempting to bring his wife on President Trump's trip to Scotland.