Using two NICs keeps things simple with physical mapping of networks, but this is all achievable using VLANs if you have a smart or managed switch.
Assume your home network is the default, VLAN 1. You can create a second VLAN, we'll use VLAN 2 for this example, where the cameras will...