ExecStart=ssh -T server 'nc 127.0.0.1 5900'
StandardInput=socket
StandardOutput=socket
in the service file and ListenStream=0.0.0.0:5900
in the socket file.The socket has to be connected to stdin/stdout instead of using SSH forwarding since SSH doesn't support fd-based socket activation.