check the curve follow and follow path with the Path selected
in the edit buttons (F9)
change the tracking with the camera selected
in the object buttons (F7)
track to is the axis you want to face forward
and up - is the axis you want to face up
check out the pics