Hi Aleksei — thanks for the question. Yes, definitely. Just be aware that all you devices will be using the Pi-hole DNS filtering unless you override them locally. For many people that may be desirable though.
What you’ll need to do is allocate a static IP address for you Raspberry Pi on your existing network. I recommend setting that value on your main router, so your Raspberry Pi gets it allocated every time over DHCP, but you could also override it on the Pi (it’s mentioned but commented out as 10.0.1.200 in the article, but yours may be different). This will become your fixed IP for your DNS server.
Then you need to update your routers DHCP client settings, so when your clients connect they are informed about your alternative DHCP server. Somewhere in your main router settings you should be able to set the Client DNS IP address (it will be the same place as the Start/End address allocation, Default Gateway and DNS). It may already be set to the gateway address, or it may be checked as ‘Allocate automatically’. Simply replace this with the Raspbery Pi static IP address you allocated above.
You could, as mentioned, also set it per connected device. Just override the DNS server IP on each machine with your new local static IP address.
That should do it. Good luck!