Unity ships with a few Light Cookies in the Standard Assets. When the Standard Assets are imported to your project, they can be found in Standard Assets->Light Cookies. This page shows you how to create your own.
A great way to add a lot of visual detail to your scenes is to use cookies - grayscale textures you use to control the precise look of in-game lighting. This is fantastic for making moving clouds and giving an impression of dense foliage. The Light Component Reference page has more info on all this, but the main thing is that for textures to be usable for cookies, the following properties need to be set:
To create a light cookie for a spot light: