Screw in mount
The screw in mount is a metal bracket that has two countersunk screw holes that you can use to mount the bracket to a surface
Tripod mounts have a standard 1/4-20 thread that can attach to tripods. It is a very secure way to attach the Smartipi.
Adhesive mounts work if you have a clean flat surface that you know will work with double stick foam tape. If you are not sure if this will stick to your surface, then try the screw in mount. Be careful to not put more weight than just the Pi and the camera case on the mount or it could fall.