Friends of an Irish energy engineer who died in a yachting accident in San Francisco Bay last year have set up a special college scholarship in his honour.