There is no mods for CS:S as far as i know.. The closest you get is -WildBill-'s Aimable S.I.R.S. M4.
--------------------------------------------------------------------------------------------------
There is also a mod called Insurgency: Modern Infantry Combat where there is ironsights on all the weapons