I really like Under Armor's "Frosty" tights for conditions like that. They have a high waist and are REALLY stretchy, but not too heavy, so they're perfect over a pair of cycling shorts. They're also pretty long, so they have lots of room for leg/knee movement.