Apparently “wizard” originally meant something like “sage”: someone characterized by being wise, in the same way that a “drunkard” is characterized by being drunk. The “-ard” suffix itself is historically related to the word “hard,” which still survives as an intensifier in modern English. (By the time “-ard” was incorporated into English, though, it no longer literally meant “hard”; I just find the historical relationship amusing.)