I used a old micro RC helicopter motor connected to a recycled tender light board. It only took a small button cell battery to power it for the speed I was looking for. The hard part was centering the blade in the motor shaft to eliminate any wobble.
You can even get gearhead motors to fit a Z Scale rotary for cheap: DC3V 3.7V 58RPM Slow Speed Micro Mini 6mm Coreless Planetary Gearbox Gear Motor