Trailcams are battery-powered self-contained cameras meant for use in the wilderness. They're easy to set up - just strap 'em to a tree or a post. It's been a few years since I've checked what was available. At the time, the available features were limited to the size of the battery you were willing to lug into the wilderness (car battery or AA battery or anything in between).
For recording stills or video at night, the cheapest camera will just use very high ISOs. They're terrible. The nicer cameras have infrared LED lights integrated with the camera. These IR LED lights require power just like a regular LED light so a local power source is required. These provide B&W stills or videos at night. As the sun rises, the camera automatically turns off the IR light and switches to regular color video recording. The camera reverses the process as the sun sets. Though IR is invisible to humans and animals, IR lights seem to attract bugs.
I've seen extremely expensive cameras that use military-style night vision. I also see "color night vision" cameras - I don't know anything about those.
Nearly all the requirements for a home wildlife camera system are common with home security camera systems. I live in a suburb of Los Angeles, California so our yards (or gardens) are not large. Most of my neighbors use Ring security camera systems because they're so simple to set up. They share videos of our local urban wildlife (coyotes, raccoons, rabbits, skunks) doing cute things during the night. The nicer Ring cameras require a power source and an internet connection (wired or excellent WiFi).
My son is currently in Thailand on a multi-week vacation. He uses a system similar to Ring. Using his cellphone app, he was able to see from his cameras that he forgot to turn off a light in his house. There was also an emergency and he needed some paperwork at his house. We drove to his house and my son unlocked it from Thailand so we could enter and find the paperwork (and turn off the light). Pretty cool.
Our local nature preserve uses a fancy hard-wired multi-camera system for both security and wildlife purposes. They have a dedicated server at the nature center that collects & processes all the videos. They use inexpensive Blue Iris software for their own use. They've also set up a Blue Iris "Guest" account so a few of their cameras can be accessed by the public (if they give you the "Guest" login credentials). HD video (1920x1080) is recorded at a low frame rate (~5-10 frames/sec) to ease the load on the server.
I'm sure if you called a local home security vendor they would jump at the chance to sell and/or install any kind of camera equipment you could possibly want. The advantage of using them would be their knowledge of what equipment works best for your needs.
[Edit: I recall another application. Someone was stealing reams of paper from my work's copy machines. I set up a dedicated computer in the next room and ran a short USB extension cable above the ceiling to the copy room. I used a simple Logitech webcam as the camera. iSpy Connect open-source software allowed me to set up motion control zones on the video output. I basically drew red boxes on the video output, if anything moved in the red boxes the webcam would start recording. The installation of the camera was announced to the group and the paper stealing stopped. I never did record anyone stealing paper, the announcement was enough.]