Without knowing the details, my guess is that some of the costs, particularly security and maybe transportation, is paid by the public dime. But the rooms, food, and other trip incidentals are paid by their own money. I'm also assuming this would be the case when any sitting president's family members go on a pleasure trip.