A Paralympic rower from Foulridge has been hailed a “sporting hero” by a councillor after he secured a gold medal.