Wireless Access Point with multiple guest SSIDs

I can't find one that works for me, does one even exist? My main requirement is that it be able to support multiple SSIDs that do not allow connected devices to see each other. One of those would be open, the other with a password. It is not possible with the current Ubiquiti UniFi devices.

Other that this, I'd need the controller software to be subscription-free, installable on my hardware, and possible to run locally self-hosted without an internet connection.

Thanks!