What exactly is a fantasy football league?

After reading this question I got up the nerve to ask a question that has been on my mind for a while now. What is fantasy football? Is it just a betting pool? Do you pick players and create your own team? Is there such a thing as a fantasy soccer league or fantasy baseball league? Is football the only sport that lends itself well to such an endeavor?