you can use spotlights and atmosphere. That relies on a background object in the scene for the effect to show.

an easier method is to use a cone primitive suitably scaled and textured .

try http://www.renderosity.com/mod/tutorial/index.php?tutorial_id=956  on the volumetric light setup .