A post that has discussion on renderers.
also a list:
Renderers come in many forms, from free to expensive and easy to use to quite complicated to use.To second Dave’s recommendation, I would try a few out, many paid ones have a free trial period too. That way you’ll get to see what works best for your abilities and budget. Looking through the galleries of the various products is also a good way to see if they achieve what you want. Most of them can produce the render you show in your example, but it would be hard to show exactly how to achieve it until you choose a particular renderer, then someone who knows that particular software can chime in with ideas, but you may get better advice on techniques on that particular renderer’s forum?