Short answer is on the boat in the center of the lake. See below the screenshots for a video. Excuse me wandering it around, the clip is from my first playthrough, lol.
RE4R: Where to get the Red9 Pistol
Website where I post Game Guides for the games I play! The site is pretty new, so expect more guides to come.