Asymptotic blow-up analysis for singular Liouville type equations with applications