SlowShutter! is an iOS camera app that allows you shoot in long exposure. Obviously shooting without a tripod (or a steady hand) produces blurry images, but practice supposedly makes perfect =)
Via Flickr:
Taken with the SlowShutter! camera app and edited in PhotoForge.