As natural light is best for creating needlework, it is also excellent for photographing it. Natural light will bring out the colors and texture of your work. If natural light is not possible a flash may help; if the needlework is behind glass it will cause a glare.
If you want to post pictures of your needlework on a web site, digital cameras are a good choice. With digital cameras you can take repeated pictures until the desired effect is achieved.