The King and the Royal Family have issued a heartfelt tribute to Jimmy Carter following his death on Sunday, but the former president's relationship with the royals wasn't always so sweet