Are you comfortable with HTML and CSS coding?
If so you should be able to use browser inspect tool to see how the example you linked achieved it.
If you aren’t comfortable then perhaps page builder is a good option as there might be something built-in already.
Unfortunately providing a full solution like this is out of the scope of this forum as it’s not theme related.
You can also Google “image hover effect css” and see lots of solutions like this one as well: