In my opinion, all solutions to this problem are horribly insecure. If sshfs supported anything other than Linux clients I'd tell you to use that on top of ssh/sftp to make things nicer. But barring that, it's possible but you're making your network more vulnerable to internal employee tampering or to being subverted in interesting ways by someone who gets through the firewall.

That likely isn't very helpful though. And you want to know the 'approved' solution that works but is broken and mis-designed from the get-go. Sadly I don't know it, but it likely involves the acronyms SMB, CFS or the word Samba and possibly the term 'Active Directory' and/or the related term 'Bonjour' (or 'zero-conf' being another word for 'Bonjour').