First, to make sure we are on the same page:
Normally a drain assembly is composed of A) a hole in the transom itself. B) a brass tube or tube-like with flange that seats more or less permanently into the hole (a) and C) a plug, either threaded or and expanding rubber "cork".
If you are discussing (B), the metal insert into the transom hole, then you must first do a few things. Remove the old fitting. Make absolutely sure that the core of the transom is dry, and that the core is not rotten. Since you "...noticed water bubbling from around the sides of the brass...", I would assume that water has gotten to the core. This -must- be remedied prior to re-attaching a fitting or further, serious damage could occur. If water has not gotten into the core not, and the hole and core are dry, then coat the sides of the hole with 3M 4200 or type 101, "pre-wet" the insert with a thin coat of sealant, then insert into the hole. Allow the sealant to "set" ( a few hours), then use the screws, covered with sealant, to finish the attachment to the transom.
I would not use "caulk" or epoxy for this task. If you are convinced that you will -never- need to replace the fitting, use 3M 5200, but I would not recommend it. I prefer either the 101 or 4200.
-edit-
Mssr. Msibley types faster than I do and posted while I typed. Two different methods, both work, in different ways. The choice is up to you.