CSR does have a marina and you can rent water mice there, but the lagoon is pretty small. If you have small children, it might be ok but I think older children might get bored soon. If you have the time, hop over to the Contemporary Resort (or probably any one of the MK resorts) and rent water mice there. You'll have a much larger area to roam around.
I think you can rent bikes at CSR as well.