Well I thought I would throw in my 2 cents just to help out a bit.
here is the full 14 cfr 91.411 regulation if anybody is interested...it is pretty clearly stated what can and cannot be done regarding static systems/transponders
?91.411 Altimeter system and altitude reporting equipment tests and inspections.
(a) No person may operate an airplane, or helicopter, in controlled airspace under IFR unless?
(1) Within the preceding 24 calendar months, each static pressure system, each altimeter instrument, and each automatic pressure altitude reporting system has been tested and inspected and found to comply with appendices E and F of part 43 of this chapter;
(2) Except for the use of system drain and alternate static pressure valves, following any opening and closing of the static pressure system, that system has been tested and inspected and found to comply with paragraph (a), appendix E, of part 43 of this chapter; and
(3) Following installation or maintenance on the automatic pressure altitude reporting system of the ATC transponder where data correspondence error could be introduced, the integrated system has been tested, inspected, and found to comply with paragraph (c), appendix E, of part 43 of this chapter.
(b) The tests required by paragraph (a) of this section must be conducted by?
(1) The manufacturer of the airplane, or helicopter, on which the tests and inspections are to be performed;
(2) A certificated repair station properly equipped to perform those functions and holding?
(i) An instrument rating, Class I;
(ii) A limited instrument rating appropriate to the make and model of appliance to be tested;
(iii) A limited rating appropriate to the test to be performed;
(iv) An airframe rating appropriate to the airplane, or helicopter, to be tested; or
(3) A certificated mechanic with an airframe rating (static pressure system tests and inspections only).
(c) Altimeter and altitude reporting equipment approved under Technical Standard Orders are considered to be tested and inspected as of the date of their manufacture.
(d) No person may operate an airplane, or helicopter, in controlled airspace under IFR at an altitude above the maximum altitude at which all altimeters and the automatic altitude reporting system of that airplane, or helicopter, have been tested.
As I have said before I am not that familiar with regulations of homebuilts...however it very clearly states in this regulation and the ac43.13 that you cannot arbitrarily install a test fitting in a static system and use it as an acceptable point of test. However if that point were considered a drain it would be ok.
Now all of that being said I doubt many shops are gonna care about that much...it is sort of a gray area
Now if for some reason you did not want to install a test point in your static system. One way to slightly improve upon your idea RVG8tor if you are having problems getting a good seal. We use a very similar method to attach our test set to static ports on aircraft that either the adapter is not available or when the adapter is it just plain sucks lol. If you go to a tac and feed store or a tractor supply they will have injection needles in different sizes. A 20 guage fits in almost all static ports. Grind the tip to flat using a sander (do not cut it off with cutters of any sort). Buy plummers putty or something similar. Shove the needle into the same clear tube that you are already using. Put aluminum tape over the port and poke a small hole in the tape. put plummers putty around the hose and needle. Place the needle through the hole in the aluminum tape and form the puddy to the hose and the aircraft in a cone shape. Like a volcano erupting your test hose out of the static port. Work all of the putty with your fingers until the hose and needle are firmly in place and if you did it right you have a leak free static adapter that is reusable. Next time just reform the putty to the aircraft (or whatever you are leak testing) just be sure not to get any putty in the needle tip and clog it up.