How often does a small/medium stream flood?

I would say it depends upon the stream: some may flood almost every year, others, only once every several years. If this is for a dissertation, you will need exact data: hydrological information should be available from the government, and you can ask experts in government departments as well. I;d say you are unlikely to find the level of accuracy you need for a dissertation, in this rather general forum.