Holme valley campsite in holmfirth has a fishing lake and its a real nice site, cheap too 2.50 for all day fishing for adults and 1.75 for kids.. and its £9 a night pitch
Dunston Heath Farm near Stafford is easy to get to, near J13 of the M6 and someone has added a review which details the fishing, it's also a very nice site.