As far as I know, ASPCA is not no kill. Why can't you make arrangements for your loving family member to come with you. Ask as many people as you know as well. Do call NSALA though. All the best to you and puppy!
North Shore Animal League does not take dropped off animals. You could and should call them for advice. There are no kill shelter options you have to find.
Definitely call North shore
Thanks! Your answer is awaiting moderation.