This is one of those projects I always meant to get around to but never found a strong enough reason.
Build a frame similar to the k1ergo/k1trainer, but instead of using a flywheel, stretch the budget and purchase a chain driven cycle trainer (Wahoo Kickr, Tacx Neo etc).
Mount the cycle trainer under the ergo or out in front, put a chainring on the shaft where the flywheel would normally sit, and run a chain down to the ergo.
The only drawback I could see was getting the inertia of the load similar to a kayak/ski, I'm not sure if there's scope to adjust these parameters in the Wahoo/Tacx software. Another alternative would be the Stac Zero trainer, which adds weights to a normal cycling wheel to mimic inertia, then adjusts resistance using eddy currents.
The world of indoor cycle training software has exploded in the last few years, plus you've got the bonus of electronically adjustable resistance and integration of ANT+ sports sensors + power measurement on the trainer. And it will be a lot quieter than any wind based flywheel.