Comment by mortos

Depending on your technical abilities, you can set up Frigate or maybe Scripted. Or possibly even just the Home Assistant integration. All of these would be self hosted options, accessible only by LAN if that's how you want it.

The Reolink doorbell camera is a typical recommendation and can work fully locally and supports well the common standards like RTSP. 2 way audio works as well.

I believe the NVR Reolink sells can also work fully locally as well. Which also can integrate to home assistant.