Create you motion guide like the previous one. You
probably would like to turn on "onion skinning" just so you can see
exactly what your object is doing.
Now double click on the first keyframe of the tween and select
the tweening tab. In the tweening tab check the "Orient to Path
Direction". Now test the movie. (control>test movie)