Is it possible to set up a 3% fee for credit card payments to charge to the future guest automatically?

You can add any fees you want to your Houfy listing:

Menu > Manage Listings > Edit > Pricing > Rates and Fees

The reason people are drawn to booking directly on Houfy is to bypass all the fees on the platform, consider including the fee in your nightly fee.