If it was a good new kayak I’d say “on the lake” is what I would write.

If the kayak sank in the water right away, you took it out in the water.