I use IP Webcam on my old phones as CCTV cameras, one for the inside of my garage and the other in my 3D printer enclosure.
Both cameras Just Work as mjpg cameras in Home Assistant. No internet, nothing.
What I haven't (yet) tried doing is configuring them in my Frigate nvr (running on docker) - that might give you the complete package you're looking for.