Someone took a dangerous and illegal shortcut to separating the fan and light switches. Rather than running a second hot, they're using the white as a hot and the ground conductor as the neutral. You should rectify the situation immediately by returning the white wire to service as a proper neutral. We can help further if you describe or post a photo of the switch wiring.
Your final comment about having no neutral in the house makes sense if you're confusing neutral and ground. Older homes commonly have ungrounded branch circuits. At the switch, you probably have blacks and whites, but no bare grounds. My guess is that the ceiling light box was added after the house was built using contemporary 14/2 with ground. Since the ground didn't have a function, it was converted to be used as a neutral for a split switch scenario.
Any transformer you use needs to be listed specifically for use in 120VAC wiring subject to the National Electrical Code. Do not use some random transformer out of an electronics supply catalog, even if it is UL listed as a component.
One of the Code requirements is that high voltage and 24VAC must be separated by a divider etc.
Generally these transformers are readily available in forms which solve that problem. For instance, a common form is a transformer built into an electrical box lid. The low viltage terminals are on the outside of the lid, solving the separtion problem.
I see these often as 2-gang box covers (4”) and I swear I've seen them in a 1-gang (2”x4”). We're not a product recommendation site but your question is do they exist; the answer is yes.
Phase issues
The problem you have adding a second transformer is phase. The two transformers will both be attached to R. If your transformer is out of phase with the furnace transformer, that means there would be 24v between your C and R, and another 24v between R and W when the furnace is off. So the thermostat would see 48V between C and W. You'd need to check with the thermostat maker to see if it can handle that.
May not need C
Some thermostats (perhaps not yours) can also scavenge the power they need simply by being in series with the two wires R and W. They do not need a C wire. However this trick only works if the furnace's control relay draws a fair amount of current. If it is too efficient, the thermostat can't scavenge enough power to function, and then they give you the advice to get a C wire.
So, you can fix this by making your furnace relay less efficient. I would say put a resistor in parallel with W and C on the furnace, except for that "must be listed" rule. So, use a furnace or air conditioning relay, which are readily available. Make sure your furnace's transformer has enough power to drive it. The purpose of the relay coil is to waste energy; the contacts are connected to nothing.
Best Answer
It sounds like you have a setup like this.
If you want to control the pump independently, simply add a switch between the transformer and the pump.