About which other carbon–carbon bonds may rotation occur?

The greatest interaction occurs around the carbon carbon single bond.

Single bonds in organic molecules are free to rotate, due to the 'end-to-end' (sigma) nature of their orbital overlap.

For example, In ethane  rotation about the carbon-carbon sigma bond results in many different possible three-dimensional arrangements of the atoms.  

In carbon carbon double bond and triple bonds the atoms are held together more strongly so they show less rotations as compared to carbon carbon single bond.