Shore diving is pretty limited, the only half decent option is Goat Island - about an hour north of the city, near Leigh.
There's also a charter company based in Leigh who run out to the Hauraki Gulf islands that would be worth a look,
Goat Island Dive, Dive trips, Scuba diving courses, Auckland, New Zealand.