All you have to do is add the .vpk files to the server's /addons/ directory.
As long as you're using a search key/mm_dedicated_force_servers it'll connect to one of your servers on the custom campaign/map.
PS: Thanks for the compliments about the L4D servers.