1) The sound one makes when they see something cute such as a puppy, kitten, baby etc.
2) The sound one makes when presented with a gift or flattering remark.
There are variations on the spelling depending how long the expression is drawn out.
Awwwwh! That kitten is so cute!
Awwwwh! These flowers are beautiful! You shouldn't have.