A kayaker who was reported missing off the west coast of Scotland has been found dead.