Not sure why you'd want two separate access points.
Many WiFi access points support multiple SSID's and VLAN's. They can bridge clients connected to different SSID's into different VLAN's on a trunk port.
Your optimal setup in terms of security would be finding a router that supports creating multiple LAN's. For example, 192.168.0.0/24 would be for your home LAN and 192.168.1.0/24 would be for your tenants. Both of these can be configured to NAT to the same public IP address assigned by Comcast, but they wouldn't be able to talk to between each other.
Simply buying two different access points and plugging them into the same router / LAN won't offer you any real security, apart from maybe the ability to disable your tenant's WiFi individually from yours.