Which video editing software can create this style of title graphic?
If you are just looking for what video editor can do a title over a video, the answer is any of them that are worth paying for and most of them that are free.  That's the majority of the point of a video editor is to blend video together and that more or less inherently requires supporting transparency.

If you are looking for the particular template used in that video, I'd suggest asking the people whose YouTube videos used it.  There are many motion graphics template vendors who provide templates that can be used for similar looks if you don't know how (or don't want to bother) to make one yourself.  There are often even some that are free.

That particular effect could be for any number of editors, composition programs or titlers though.  It might come with one directly as an included template or it might come separately.  Nobody is going to know all templates everywhere, so the best bet is to ask the people that used them.

If you are just looking for software in general, I use Adobe After Effects for most things like that, but it's a professional level product so you may not want to go that high end.  Premiere Pro is also able to do a level of motion graphics, though it is more limited.  I'm not sure on the lower levels, but if text overlay or layer transparency or something similar is listed on the features of a product, it should be able to do something reasonably similar.