Cameras for game consoles are available from Sony, Microsoft, Nintendo, and other companies who manufacture the consoles in question. Alternately, one can find third-party USB cameras as long as they are compatible with the console. Examples of brands include canon, logitech, and LG.
Trail cameras are created by putting together motion sensor triggers with cameras to capture the pictures of your game. You can basically build your trail camera to suit your needs, it does need to be light weight to be able to move on and off the trail easily.