I've only ever had goldfish and small pets pass, and we bury them in our garden. There's a little corner that we use, it's underneath a little bush that grows red berries, and it's really pretty.
I don't know what we will do when my dog passes, I think it'd be best if I didn't think about it.