It's not unprofessional at all; at worst, it's discourteous, because notice of departure has zero to do with your professional conduct, it's a courtesy. You can professionally quit on the spot, look:
"Due to a change of personal circumstances, I will be resigning immediately, effective at the end of the day. I will work with you to make this transition as smooth as possible within that timeframe, but it is not negotiable."