Although it is clear in this Waggoner article, I cannot find any news release or US government statement that specifically states that the US border is open to Canadians for non-essential travel for "private vessels". Car - yes, ferry - yes, commercial vessel - yes, but no mention of private or recreational vessels. Unfortunately Waggoner's did not provide a reference or source.
U.S. BORDER OPENS NOVEMBER 8 FOR FULLY VACCINATED INTERNATIONAL TRAVELERS
U.S. BORDER OPENS NOVEMBER 8 FOR FULLY VACCINATED INTERNATIONAL TRAVELERS