Family friendly water

We would like to have a pint near the castle where can enjoy sports as kayaking, improving the accessibility of the corner where the castle is.