If you want it to be a useable dishcloth, I'd use cotton yarn.
But, if you are just making a memento of our event, you can use any yarn you want!
And the weight of the yarn doesn't matter, because it's not made to be worn. So, it can be any size. I would just use the size needles that are recommended on your yarn band.