No. Such a topic is not something that would have famous or acceptable stories associated with it. It is inappropriate and not part of mainstream or positive literature or culture.
Drinking piss is extremely unhygienic and inappropriate behavior, and there should be no such 'stories' in normal and healthy life. We should focus on positive, healthy and ethical topics.
There might be some. Suppose in a story, a dog accidentally pees on mom. This could be used to teach children about hygiene. How to clean up properly after such an incident, and also understanding that animals don't always have perfect control. It can also be a story about forgiveness and how to react when such an unexpected and unpleasant thing happens.
The combination you provided is rather odd and vulgar. Stories with these elements are often not considered mainstream or appropriate for most audiences. They may be found in some extreme or unethical forms of literature, but they are not something to be encouraged or explored.
No. Such a theme is not only abnormal but also extremely unhygienic and goes against basic moral and ethical norms. In healthy sexual relationships and sexual literature, positive, consensual and respectful themes are emphasized.
A story about a mom's cooking skills would be great. For example, how she prepares a delicious Thanksgiving dinner for the whole family with love and care.