The clicking is the relay closing, which should mean the horn will work.
How are you closing the circuit without using the horn button? Sounds like a switch wiring problem to me.
You should hear the relay when you press the horn switch?
You won't get any power at the horn without the switch being pressed, else the horn would permanently be on!
Martin