Add a white to black gradient to the spot light, the distance the light is visible can be adjusted using the gradient's range and offset options. As you can see in this example, the bottom image is the same scene with the gradient added to the spot light.

Stephen Ray