I have an 1890s balloon framed 2 story house.   It has a basement, and the foundation is mortared stone.    The rim joist and floor joists sit directly on the stone foundation wall, there is no sill plate.  The rim joists are pulling away from the floor joists at the bottom (forming an upside down V).  I am planning to (working in sections) jack up the floor joists about 1/2 inch and then using structural screws from the outside of the rim joist through the end of each floor joist to try to pull them back together, or at least to stabilize them so they don’t move further.   While I have the joists up I would like to insert a moisture barrier between the stone and the joists.   Future plan is to have the rim joist and foundation walls sprayed with closed cell foam for insulation and air sealing.   I aware of the risk to the rim joist and the ends of the floor joists from moisture that has nowhere to dry, thus the moisture barrier.    
    My question has to do with choice of moisture barrier materials, and how to detail them.   My first thought was to use the standard roll of foam sill seal.   If I use that would I use an adhesive to seal it on the outside to the top of the foundation and find a way to hide it visibly, possibly with a piece of trim.    Or would it work better to staple the outside to the rim joist and then tape it to seal the edge of the sill seal.   My worry with that is that any failure of the tape would allow water to enter and be held against the rim joist.   
    Second choice would be to use a self adhering membrane of some sort.   If I use that, I still have the question of putting the sticky side down and sealing the outside edge to the stone, or put sticky side up and sealing against the outside of the rim joist, with the same moisture issues.   
Any advice is appreciated!