If you are in Connecticut, there are a TON of various organizations that can help you get acquainted with the New England diving scene. I know of this fact personally as I have a friend who just started diving in CT. Diving in NE can be a bit more of a daunting process as many of the divers in the area are hesitant to welcoming newbies since the conditions are much more difficult than in the tropics (think: cold, dark, low visibility, difficult current) but if you are persistent you can absolutely make a career out of it.
Perhaps most important however is going to be deciding with which organization you would like to pursue a career. PADI? SDI/TDI? SSI? NAUI? GUE? Try picking an organization/trying multiple organizations, taking classes with those organizations and then determining whose methodology you like best. Additionally, I would recommend that you go to a few different dive shops in the area and explain who you are, what you want to do, and if they have any diving classes, diving groups, or dive trips that you can take part in. Additionally, since you are in CT, you should look into joining SEACONN, as I know they frequently will go on night dives.
If all else fails, you can also look at booking a liveaboard, which some of them (there is one in particular that I know of which launches out of the Bahamas) can get you 15-25 dives over the course of 7 days for under $1500.