that's a REALLY open-ended set of questions.
first of all, making it a 'good' path animation will depend heavily on what you're using the path for. If you post some sort of video or something, the question becomes more answerable.
for the second question, most of the answer above applies. Besides that however, simply attaching the camera to the path is a good start.