I just got a Meziere electric water pump. That's the brand that I've heard the most about. Is it a good brand? I think so, but I'm not sure. A lot of Stangers seem to use it. Is it the best brand? I don't know.
I got an electric, because I'm installing a Kenne Bell supercharger, and I wanted a water pump whose performance did not depend on engine rpm. I've heard that belt-driven pumps often spin too fast at high rpm, and then cavitate. Also, belt-driven water pumps spin too slow at low rpm.
I think it probably does give maybe 10 horsepower right off the bat, because it runs off of electricity, not the belt. However, electricity comes from the alternator, which is running off of the belt. But I guess the alternator generates electricity whether anything uses it or not, so as long as the alternator is not yet maxed out, it seems like using it to run the water pump would give you extra horsepower.
It should also result in even more horsepower, ultimately, because your engine will have better cooling.