There are some great lakes for novice paddlers or the Oker river for the more experienced there is a great range availiable here in the Harz.

A Complete Guide to the Oker River

Check out these YouTube videos of some kayaking on the Oker.