As far as paid options go, there are a few products out there, most notably AtmosFX. They offer some superb visuals, ranging from simple and fun Loops to full on terrifying, realistic scenes. You can take your pick based on your audience.
Read the article here: http://halloweenerrific.co.uk/halloween-decorations/using-projectors-for-your-halloween-decor
