Rain Ripples Texture on Puddle
A puddle being hit by loads of raindrops which form ripples on the wet floor.

You may create a plane above any ground and make this water layer semi-transparent as demonstrated on the web page.
 
Decal: Asphalt Puddle Map
It is an asphalt ground which is full of puddles. You may extract related PBR maps as decals and combined with your existing ones to create puddles for your models.

The colors of the puddles and ground, and the roughness of the puddles and ground can be changed by the Substance SBSAR file.
Water Stain Texture
It is an imperfection texture of water stain. This type of water marks can be commonly found on the glass of a bathroom.

The SBSAR allows users to change the size and amount of the stains.
 
Frozen Icy Surface of Lake or Pond with Cracks and Frost
It is the water surface of a frozen lake or pond. The thin ice is shattered into pieces leaving numerous cracks. Frost and broken ice can also be found on the material.

The SBSAR file allows users to adjust the amount of cracks, frost etc.
Stylized Water Waves of Pools
It is a stylized version of water waves having shiny creases. The material is good for texturing lakes, swimming pools and ponds.

The color, the number and width of shiny edges can be tuned in the SBSAR file.
Water Lily Leaves Texture
They are leaves of water lilies on a pond. Waves and ripples can be found on the water surface due to wind.

With the sbsar, the degree of leaf damage and intensity of waves can be set.
Cup Stain / Glass Stain / Water Stain
This texture is an imperfection. It is glass stain. When a glass of cold drink is put on a cloth, it will leave a water stain.

There are 6 variations which should be enough for scattering randomness.
Rain Droplet Texture
They are rain droplets. This texture can be applied to a plane. the droplet will become rain drops on a glass window. It can also be applied to multiple planes to create raining effect.

This texture should be used with the opacity mask because water drops are transparent.
Sandy Seashore Ground Texture with Water Puddles
It is a ground near seashore. This seashore is entirely covered by yellowish sand.

Due to uneven surface, sea water is trapped in some holes creating water puddles in this sandy land.

Water and wind marks can also be found on the beach.