Hi and welcome to the forum.
I can’t tell you anything specific about the fabric - I just went to fabric shops and bought samples of fabrics that I thought might fit (they didn’t have names or anything). Just get the cheapest silicone you can find and experiment. You’ll need to try it out anyway because it requires some experience to get everything done right: you need to find the right pressure for the squeegee (which may be different for different fabrics), you need to learn the best way to remove the fabric from the silicone such that it doesn’t stick to the fabric and ruin your texture, etc. ...
There are a lot of very different fabrics that all worked well more or less. In general, they all were curtain-like, but a fine curtain (fine in the sense of high density; probably finer than the ones you would put in front of your windows). I had some with a very fine texture, others with rather rough ones - that is, it felt fine or rough when being touched. The very best I found was a pretty rough one, but its structure and holes were still ... “capillary” somehow. It’s difficult to describe. The holes of that material were about 1/3 to 1/2 of a millimetre. In general, the holes mustn’t be too big, as the silicone will then stick to the acrylic. The biggest problems I had were caused by the fact that I needed a really big surface (1,2x0,9 metres), and as the silicone cures fast, I messed it up a number of times because I was too slow and the silicone stuck to the fabric instead of the paper when I pulled it off (but it might have been due to my paper, I didn’t use vellum but some strange big plastic paper thing which must be at least 15 years old, probably more :D).
When I did my experiments, I found that one can see the parts of the surface that will be sticky already directly after applying the texture (when looking from certain angles). It has a wet, shiny look to it, while the areas that don’t stick look drier (however, nobody ever mentioned that here, so possibly it was my silicone which only...). If the silicone is not cured yet, you may put the fabric back on and try to fix these areas.
Oh, and give your sheets enough time to cure. Some of mine did stick to the acrylic for more than a week before being really usable, although the room was dry and warm.
Well, I hope this helps. Good luck.