Site2Site, allows you to access the other subnet. But all of your data goes to normal internet.
I think you can set the dns to your smartDNS server. So the dns is resolved using your own server when you built a Site2Site setup. But your data will go to your normal Internet and I am not sure if this will work for your application.