BC Ferries connects Alert Bay on Cormorant Island with Port McNeill and Sointula. The crossing is short, but schedules matter, especially if you are trying to make a day trip.
Port McNeill is the usual mainland base on northern Vancouver Island. Once on Alert Bay, the village waterfront is walkable, though a bike or car helps if you want to reach the farther ends of the island.