I think getting another dog would help me feel better

Yes, you are right you will be occupied n like fully busy it's no joke to own a dog

My dream is to one day have a big enough yard to get several dogs.

Never looked back when I acquired my second. Unconditional love.

What kind?

I would choose 'shitless' were I you :)

Hmmmmm.