There is is this DX bike horn, working off a manually operated pump. Off the bike it sounds pretty loud, but its mounting hardware is pretty lousy. I've got one but never got around to mount it.

In everyday life I use a DC moped horn powered from 5 rechargeable AA batteries. In my case, the batteries are charged by the hub dynamo but the two do not need to be connected.