I would like to draw a figure for nucleic acids strands in pipe-like appearance with some curvatures and colors. I want the figure to be attractive, not just a collection of dull thick lines.
Do you want a detailed molecular model or a schematic representation? In the latter case, make sure that you draw a right-handed helix, even Science and Nature embarrassingly had left-handed ones on their covers!
There are several programs that can draw molecular models from crystal structures (pdb-files), Pymol has been mentioned, but also DeepView, Rasmol, Chimera and jMol, amongst others. Personally, I use DeepView, but mostly because I have been using it for many years and know exactly how I get the results I want.
For more schematic representations, you can use vector drawing programs like DrawPlus, Illustrator or xFig (the latter one is free). You could also use CAD-applications like AutoCAD or TurboCAD, they can render things in 3D. This could also be done with Blender or POVray. It really depends on what result you want, what software you are comfortable with and what you are prepared to pay for it (an AutoCAD installation goes into thousands of $).