For an actual AP, check out the Unifi AP line. https://www.ui.com/unifi/unifi-ap

For a home wireless router, you can buy a supported device and install OpenWRT. https://openwrt.org/supported_devices

The access point I use is a UniFi AP-AC-Pro. You can create multiple wifi networks and map each one to a separate VLAN. I also use UniFi switches and a UniFi Security Gateway, but really any equivalent that supports VLANs will work.

I believe I also accomplished the same thing with an Asus router/AP running DD-WRT, but that was a long time ago.

I built my own with OpenBSD to get this and other functionality

Not to mention the cool toys you can setup to see what is happening

https://undeadly.org/cgi?action=article;sid=20140228093820

ASUS routers do too if you flash with Merlin https://www.asuswrt-merlin.net/