Leaving a "trail" from a stationary object, when the camera moves

Usually the object velocity/distance is used to spawn particles, so spawn over distance should be good enough, or even just constant spawn rate. However if you need more control you can create custom spawning behaviour .
Even when you move camera only, if you have local positions for spawning you can calculate offset in world space and still spawn particles.