As far as I know there is no standard procedure for designing such filters. A simple approach would be to design a standard second-order low pass filter with the given cut-off frequency (such as a Butterworth filter), and then re-design the numerator coefficients such that the total filter approximates the desired magnitude roll-off. This is basically a (linear phase) FIR filter design problem, which is very straightforward to solve.
Let $M(\omega)$ be the desired magnitude response. On a log-log scale, $M(\omega)$ is piecewise linear ($0$ dB in the passband, linear decay $r$ dB/decade in the stopband). Furthermore, let $A(\omega)$ be the frequency response of the denominator coefficients of the original second-order filter. Then the desired response for the new numerator coefficients is given by
$$D(\omega)=M(\omega)\cdot |A(\omega)|\cdot e^{-j\omega}\tag{1}$$
where the exponential term is a linear phase term corresponding to the delay of a second-order linear phase FIR filter ($1$ sample).
Any method can be used to design that $3$-tap FIR filter (the numerator coefficients). I used a least squares design and the result is shown in the figure below (with the original Butterworth filter in blue, the desired magnitude response in red, and the modified Butterworth filter with re-designed numerator coefficients in green):

If you need a better approximation you can increase the order of the numerator (without changing the second-order denominator coefficients). So you'd get a biquad concatenated with a (short) FIR filter. The figure below shows the approximation with a $10^{th}$-order numerator polynomial and the second-order Butterworth denominator coefficients (in green):
