Hello, these "visual effects" are generally described as "Motion Graphics", so maybe do some research with that keyword.
Regarding the video, this style of video can be created with Premiere Pro or After Effects, as well as many other video editing software. I don't know if there are any apps...