Self-similar solutions with fat tails for Smoluchowski's coagulation equation with singular kernels