Jordan Lake, Falls Lake and Shearon Harris are big lakes and accessible by boat, but also have bank fishing access points. Bond Park lake in Cary, Lake Pine in Apex, Lake Lynn in Raleigh, Umstead park has a few lakes. Alot of them are mentioned in past threads on here, read a few pages back and I am sure you will find more on each of them.