Getting that type of sound depends more on your tuning than the heads your using, although certain heads will lend themselves more to that type of sound than others. It might be a little more difficult to get that tone out of a steel drum than a wood drum, but it's not impossible.
As odd as it might look on a steel drum, I would try a Remo Fiberskyn batter head in combination with a standard, thin snare side head. The Fiberskyns have a very warm tone that might give you a pretty fat sound on your steel drum when tuned a little lower. I would start by tuning both heads pretty low at roughly even tension. Tightening the heads from that point will gradually give you less "thickness" and more "pop" in the tone of the drum. Find the sweet spot to your ears.
One more thing. I would have your snare wires on the loose side. Letting them buzz out will give you a fatter sound, as well.