Paper camera software filters for post-production?
Adobe Premiere should do exactly what you want - it has a ton of effects plugins.

As to your second question, any screen grabber video software should let you do this - you play the video and have your wacom sketch overlay running, and just use the screen grabber software to make a video of everything displayed on the screen.