Not sure how well these tools cover your needs, but this sounds a lot like an inventory/asset manager that is focused on communities rather than organisations/companies. Have a look at the ones listed here
- https://github.com/awesome-selfhosted/awesome-selfhosted#inventory-management
- https://github.com/awesome-foss/awesome-sysadmin#it-asset-management
Most of them also have a demo. I've heard a lot of good things about SnipeIT, and it looks like it can also do what you want it to do. Keep in mind though that most of these are inventory/asset managers that are intended to be used in an organisation, so the UI might be a bit ugly/cluttered/unintuitive to share it with your neighbours/church people