I'm looking for some advice about what to get and what to set up for this scenario.
There is a B&B with 3 rooms, each having 2 CAT 6A cables wired to them, and a TV with Chromecast hooked up. The goal of the setup is to provide all guests with a wired and wireless network, where devices within the room can communicate with each other, but not with the devices in the other rooms. Importantly, it should not be possible to access the Chromecast of the TVs in the other rooms. In addition, the owners also live in the house, and therefore another isolation needs to be established.
From what I've found, it seems VLAN could be used to isolate the wired connections, and that this needs support on both router and switch level. I was thinking that having 4 distinct VLANs that cannot communicate with each other at all (3 for the rooms, 1 for the residence), should be sufficient.
For wired, this is what I had in mind:
Modem ----- Primary router ----- Switch ---- Room C x 2
/ | \
/ | \
Secondary router | \
(residential) | \
| \
Room A x 2 Room B x 2
As for wireless, as far as I understand, it's not easily possible to have one SSID and differentiate based on a password, so it'd have to be a different SSID per room, and depending on which one you're connected to, you would be part of that room's VLAN.
I'm currently considering using a secondary (the currently in-use TP-Link Archer C9) router for the residential area of the house, so that it can be configured separately. However, I think this might cause issues, so if the VLAN is enough security, maybe that'd work too.
My question is if this is a good setup, or if you'd recommend a different approach. I only know the basics of the hardware level of networking, so I'm open for any suggestions.
Additionally, what kind of hardware would you recommend for building such a setup? The amount of bandwidth is mostly just things like Netflix/YouTube streams, on the order of at most 200mbps, so nothing spectacularly high end should be necessary, though the amount of clients in the room can easily be 10 for the rooms, and about 16 for the residential area.