For any product that has video added, the video will show on the hover for the standard, out-of-the-box layouts.  For custom designs, there may be additional work.  

The larger the image in the catalog, the better the video will play on hover.

Learn More on Video Specs- Product Videos- Supported Formats, Best Practices and Naming