I learned the MJB's Cocaine Habit Blues more than 4 decades ago which doesn't make me an expert but to me "Honey take a whiff on me" means "let me give you a snort of cocaine" or "allow me to provide you with a sniff of cocaine" or "have a bump of cocaine from my stash".