What a cool garden plan!
Any of the rugosas as would work well, I think, because the texture would complement the conifers in the winter, and the hips would add color. The rose hips are edible by humans, with preparation, and surely the petals would taste as good as they smell. Maybe someone else can suggest a rugosa that is thornless. There may not be such a thing, though.