In general, If I bring just two, I want one rod for heavier stuff (3/8 and over), one for lighter stuff (under 3/8oz). Consider shorter lengths than you might use on a boat (especially if you are short, like me -- I don't fish with anything over 7'), and possibly even softer actions. These can help in landing fish, since you are really limited by space and your own armspan.
Rod 1: 6'6"-7' baitcaster Medium-heavy power, fast action -- jigs, t-rigs, carolina, spinnerbaits, frogs, buzzbaits, walking baits, heavier cranks.
--I'm a spinning junkie and I actually get by with a 6'6" MH-F spinning combo here, but almost everyone else would recommend a baitcaster.
--On treble baits like crankbaits and some topwaters, back off the drag a bit.
Rod 2: 6' to 6'9" or so spinning, Medium-light power, fast action -- shakey heads, mojo rigs, weightless plastics, drop shot, finesse jigs, lighter cranks and topwaters, light tubes and grubs.