I would go with Ben Nye MagiCakes.
They are a water base makeup that barely needs any prepping. It barely rubbed off on anything that I was in contact with and I used it on my face, neck, hands, forearm and feet. It barely need reapplying and it can be seen here in action during NYCC 2010 convention.
(Please ignore the fact that I forgot to put it on my hands. I didn't have time too lol)
However I suggest getting Ben Nye Final Seal Spray just in case. =] I used that on my hands and feet and the makeup stayed on pretty well. I suggest layering the makeup onto your face a few times with a spray in between for extra strength.