My understanding of name servers are where is your domain going to be recorded. For instance, my domain may be something.com but the name server tells the browsers to send the web traffic to 50.50.50.50 where the server lives.

According to this article, https://blog.cpanel.com/how-to-create-your-own-name-servers/, you can do it yourself by manually entering the IP address of the server that your website is hosted on.

You could also use a wifi extender that was connected to a different VLAN through your managed switch

Why are you running 2 piholes? Is it so you can also run your secondary DNS?