That can be done with some models of camera, but for the volume of images you’d be getting over a time frame like that you’d still want it connected to a computer and loading the images directly to the computer instead of being stored in the camera.
In addition, you’d be constantly running the risk of moving the tripod every time you downloaded the images.
A good option might be a C-mount lens mounted to a dedicated CCTV camera. There are lots of C-mount lenses available and they tend to be relatively inexpensive as they’re small. C-mount lenses are made for CCTV type security cameras (of which there are thousands of varieties in all sizes and styles), and there are also adapters for the C-mount to standard cameras as well (I know folks who use them for hand-held macro photography).
This would allow you to install a small CCTV camera exactly where you want it, without needing the bulk and expense to a full size camera and tripod, and have better resolution than a webcam, yet retain the optical options of a standard camera.
Standard security camera software should allow you to have that automatically send and store the images in a remote drive, either via a direct hardline, or via wifi or cell networks.