For this, I would use the watercolor page presented by @Pesi, in the version I fixed.
Simply unzip after downloading and install the bundle contained in the archive first before you open the Krita file in Krita. If you do this you have a good watercolor paper, there you can still fine tune the effect by manipulating the opacity of the grain and the fill layer. For more hints regarding this paper, see my post on this.
Pesi presented this watercolor page himself a few posts above the post of mine, this paper of Pesi’s contained a small bug which is fixed in my version of it (it is not unusable as a result, just partially uncomfortable), and by the bundle added by me, you don’t have to assign the two pattern files to the corresponding layers in my variant anymore, this is all included.
If you also download the set of watercolor brushes from Pesi, he presents it in the first post of the topic, then you should have everything you were looking for, so the paper and the brushes. At least that’s what I think, you may have other requirements, but the texture should be easiest to achieve with Pesi’s paper, I’ll leave the choice of brushes up to you. If you want to try some other papers instead, I have attached a link to 3 papers from Ramon too.
And remember, the more pressure you use with watercolor brushes, the less paint is applied, at least usually. But for “mouse painters”, who have always maximum pressure, there is a watercolor brush set from @RamonM.
Pesi’s watercolor page with Fix:
You can get Pesi’s watercolor brush bundle here:
Ramon’s watercolor bundle for mice:
https://files.kde.org/krita/extras/water_color_brushes_for_mice.zip
Ramon’s watercolor bundle for stylus and mice:
https://files.kde.org/krita/extras/WATERC%20stylus%20and%20mouse.zip
Ramon’s Templates (3 different papers / canvases for Krita):
https://files.kde.org/krita/extras/Smart%20Canvas%20Templates%20for%20Krita.zip
Michelist
Add/Edit: 1 Download link renewed