Noticed your question was asked few weeks ago. I am a Realtor in Sykesville area. In our town there's the Piney Run Park, which is a 300 acre lake with 550 acres of fields surrounding the lake. Piney Run Park offers hiking, nature center, tennis courts, playgrounds, and of course boat rentals and fishing tournaments. They allow small fishing boats, but no large motor boats.
Also, our area has fishing opportunities at the Liberty Reservoir, which covers 3,100 acres. If you're looking for a second home on a lake I can provide you with recommendations in MD and Va. Contact me at firstname.lastname@example.org