I am not married yet but I can give you a bride's view that is planning to do it.
1. I have attended local weddings where they did a sand ceremony and I thought it was really meaningful. At one wedding they actually chose to have many different colors and involve the bride and groom's parents. (The parents poured first - "laying the foundation") I also love that this is something tangible that you can keep from your wedding day that you can display next to a framed photo from your wedding day.
2. As for getting it home - I think a frame might be easiest. I ordered the following frame from etsy:
The frame came with the following instructions (I don't have them with me so I am paraphrasing): The part of the frame that holds the sand is a clear plastic box that fits into the frame behind the etched glass. The box is removable and has a hole on one end only. After filling the box during the ceremony you tape over the hole at the end of the box and flip it over and insert it into the frame. So now the hole of the box is pointing down and is inside the frame so it cannot empty and the cut-out in the top of the wood frame is now over a solid part of the plastic box.
Two things I will do: 1. After the ceremony I plan on tapping the frame/box to settle the sand as much as possible to fill it up to the brim - repeating a few times if necessary. This way there will be no need to redo it once you get home. 2. possibly putting something (like a piece of a cotton ball) between the sand and the tape before I flip the box over to make sure the sand never makes its way past the tape.