Lots of nice size bass, catfish and panfish in Muddy Run Lake. The resevoir has lots of fish too as well as some pretty nice size Stiper-Hybrids (big fun on a fly). Not too much for trout fishing down in that area this time of year, that I know of. Yes you can use a kayak on the Lake, but I don't think they allow any watercraft on the resevoir. Also if you keep heading west on RTE 372 past the park entrance, you cross the bridge just below Holtwood Dam. Cross the bridge, and turn right, park in the gravel lot and go down to the Susquehanna River. Very shallow and rocky with good wading, lots of pocket water and a fair number of smallmouth bass. THis area may still be closed to fishing temporarily while they work on the dam, not sure. Also if you turn left after the bridge on 372, you'll be on river road. Follow it for @ 1/2 mile and there is a PFBC boat launch area. Slightly deeper water but still wadable in most areas, lots of big rocks and structure. There are Musky in the river as well and I have heard this is a good area to catch them on BIG streamers!
http://www.muddyrunpark.com/.
http://www.hookandbullet.com/fishing-holtwood-dam-susquehanna-trails-pa/