A Scottish harbour has opened fully for services after a major upgrade