What repercussions could I face if my counselor has ties to the NGB and discloses to my unit that I am trying to go active duty?

Your unit doesn't get a choice in submitting your 368, the unit does not get to approve or deny it, they submit through BN, BDE to your state G1.
State G1 approves or denies, then you contract to active duty, submit the contract and orders to G1, and they discharge you from ARNG.
You would ETS about 2-3 months before that process could complete, so it would be a waste of paperwork for the 7-9 people involved, including you.
Contact a recruiter about 30 days out from your ETS to start the paperwork, and go back the day after your ETS.

During my military I did the same thing, NG to active duty, my NG unit fully supported me.

It's your choice to switch components. You can however have some bonus payments recouped depending on payments received and time you have served. If that applies to you, make an appointment with the states incentive manager to get the real scoop, so you know what to expect.