If you're deactivating campaigns that are truly no longer active, I don't think it should have much impact. But if you're deactivating campaigns that are still actively syncing leads to SFDC, that would probably create some issues.
If they're still syncing over leads though, they are actually still active. I would definitely keep them that way in SFDC.
That's a good question though--anybody else?