In reply to olddirtydoggy:
If you lesson your criteria a little there must be some good river trips were you can stop off for a climb.
The river Eden in Cumbria would be a good day out, get in at Lazonby paddle down river for ~10km, pull out at the sandy bay at Armathwaite do a few climbs then continue down to the exit in Armathwaite itself, which has a couple of pubs, the Fox and Pheasant recommended.
From the river guide.
Grade II to III
Time 2hrs
Length 13km