I associate weddings with happy domesticity, so here's a little scene from John and Rodney's wedding. Although since they're still on Atlantis, I'm not sure how domestic their life will be :P
Preview:
Unfortunately the wedding rings didn't really show up after I shrunk the image down, but you can sort of see them if you squint?