No bail for man accused with gunning down a councillor in front of his family