It's not open source but the Unifi Protect Doorbell G4 does not require a subscription/cloud connection. I haven't purchased it yet (it's on my todo list), they want you to use their Unifi Protect software to get all the features out of it. I've seen that it's possible to hook it into home-assistant which is open source.
https://store.ui.com/collections/unifi-protect-cameras/produ...