Kayaking with a 3yo - realistic expectations?

Has anyone taken a very young kid kayaking? My wife wants to try it this summer but I'm not sure what to expect. Should I be looking into tandem kayaks or is there a specific kid boat? We'd be on calm lakes only. Is this actually doable or are we setting ourselves up for frustration?