Carrara (http://www.daz3d.com/) or 3D-Paintbrush (http://www.3dpaintbrush.com/) are probably a good place to start looking, they're inexpensive and kind of more aimed at someone who may not have a whole lot of prior 3D experience.

But as you can see from the discussion, there are a lot of different types of rendering programs available.

- Michael