An unbiased survey of black hole activity in the local universe