Flying with a young child – is it possible?

One of the things I used to dream about before getting my license was to fly my wife and two-year old daughter around, sharing the experience of flying together. I would daydream about flying off to a fun destination, grab lunch (and coffee) and then enjoy a nice flight back to the home field. I often questioned if having an enjoyable flight was doable with a two-year old.