On transactional systems, /etc is a fairly complicated mounted filesystem, yet it is still possible to put unit files in it. So if it can be done for /etc, why not for /usr/local, too?