PhotoShop has loads of artistic
renderings. This is one called
colored pencil. De-saturate an
image, then play with the
stroke pressure and brush
width until you get the
result you want.