I've checked all of the campsites listed on the Leeds City Council website and then searched Traveline for public transport options. There seems to be only one campsite which is anywhere near to a bus route. (Even then, it's about a mile's walk). There's no mention of boating at this campsite (or any other in the area).
For what it's worth, the campsite is called St Helena's. I can't give a direct link to the site information because it's one which 'times out'. Instead, go here:
http://www.leeds.gov.uk/Leisure_and_culture/To urism_and_travel/Tourist_accommodation/page.as px?path=%2fleisure_and_culture%2ftourism_and_t ravel%2ftourist_accommodation%2f
Select 'Camping', click 'Search', then go page 2 of the results and click on the relevant link.
Here's the location:
http://www.multimap.com/map/browse.cgi?lat=53. 8747&lon=-1.6356&scale=25000&icon=x
Bus 757 (Leeds to Otley, via Leeds/Bradford airport) runs along the green A-road, on the left of the map. (It's about a mile from the crossroads to the campsite but I don't know how close the nearest bus stop is to the crossroads).
Chris