Most people stick their SLR in a normal riding pack, perhaps wrapped in a waterproof or t-shirt.
There is a LowePro pack that can also take a bladder, but I don't think it's bike specific as such & is pretty expensive.
I use a small 'holster' back from ThinkTank Photo called a 'Digital Holster 10' with a chest harness also from Think Tank.
I stick it on before my rucsack & the straps are discreet enough to not get in the way & you can pull it right into your chest out of the way. They do different sizes, depending on the camera body – my D80 just fits into the 10, which is the smallest one they do, but if i was buying again, I'd wanna try the 20 to see if it was more suitable.