I think this is not possible to configure just with yunohosting standard tools. My guess would be you would not need yunohost to do so. I have a blog made with a static site generator and I just push the whole output to a directory under /var/www. Plus there is an nginx running as Webserver and to redirect traffic to subdomains.
A minimal setup would be:
You configure your VPS to be able to access it via ssh, login, install a Webserver like nginx, Apache or others, configure the server to point requests to your IP or domain to a local directory on your server (e.g. /var/www/yoursite on Linux), write some hello world html file, copy that file via scp to /var/www/yoursite, voilá – you just created a (very simple) website.
If you want a little more bling bling you could use a static site generator. See https://jamstack.org/generators/
With a SSG you would initialize your site on your local machine, write some markdown and put in in your site generators folder structure and run the command to create the html files from the markdown. The output is normally a specific folder you could then copy to your server, as mentioned above. Or you could set up git on your server and use git commit and git push to push changes to your server. This is what you had in mind.
I find it easier to just use a graphical client software like Cyberduck to drag and drop the whole static site generator output to my server.