Is the cat's water bowel a plural possessive?

No, the possessive noun cat's is the singular possessive form.

The plural form for the noun cat is cats.

The plural possessive form is cats'.

Examples:

This is the cat's water bowl. (singular)

All of the cats' water bowls must be washed daily. (plural)