I use the same IMX291 camera modules that are used in the GMN meteor network but retaining the IR filter so that they can be operated in colour mode. They can be used in power-over-Ethernet mode so are very simple to install and they can stream MP4 video to multiple clients. I just put the modules in a waterproof dome.
https://www.aliexpress.com/item/1005003139136600.html
Have a look at the talk I gave in Elgin a few years ago:
youtube.com/watch?v=IvTMV1CVUyM
Any camera based on a Sony Starvis sensor would probably work fine.