As others have pointed out, Creative Conners is undoubtedly the best automation solution for scenic automation in small to medium sized theatres.
However, if you're not prepared to invest thousands in a complete
system, I suggest you explore other options.
One of these would be to design a
stage deck using the same principles used for modern automation. Kicknargel has written a pretty good overview of how such a
system would work.
Instead of using electronic winches and a complicated control
system,
hand winches controlled by
stage hands could be employed. This method of 'automation' has been around for 100+ years - in Italy at least.
Take a look at this video of an Italian musical:
The scenery is moved using the method I have outlined here, and it looks pretty good. I was convinced that they were using some sort of computer controlled
system until I contacted the scenic studio and they explained to me how it all worked.