Harry Dresden
Harry Dresden is the only wizard
advertised as such in the Chicago
telephone book.  He works as a private
investigator of sorts, and a consultant for
the police when unusual circumstances

He is under the watchful eye of the
Council Wardens for using black magic to
kill Justin Morningway, even if that was in
self defence.

He is also Sam and Dean's cousin, and
feels very protective toward the last
remaining members of his family.
Especially Dean as he has no magical
ability at all.