I really good video that I own that teaches some of the card productions you are seeking is from Jeff McBride: The Art of Card Manipulation.
This is by no means the only one out there, or necessarily the best, but Jeff McBride is an amazing teacher and he can really get you going with certain sleight of hand and performance pieces.
I'm backing you up on this one. Not only is he a great teacher, but he's one of the best at what he does. He even has his own school opened up with Eugene Burger I believe.
Maybe start with his DVD "Manipulation Without Tears". It's a great introduction and it doesn't put you right into the expert moves when your a beginner.
There are many DVD's on this subject.