Pi Camera mount is a great accessory for Pi shutterbugs. Little screws attach the Pi Camera solidly and the design allows for multiple positions. There's also a 1/4" hole that you can use to attach the camera to a standard camera tripod mount.
This works with the Pi Camera version 1 (5 Mpixel) both plain an NoIR.And the new V2 8 Megapixel cameras.