Mayor Brad Woodside said David Kelly died Saturday after a seven-year battle with a brain tumour.
He was 49.
Woodside said Kelly not only championed the needs of the area that he represented, but worked hard to tackle issues facing the city as a whole.
"David was an excellent city councillor and he represented the citizens of Silverwood and Garden Creek very well," said Woodside. "While he often referred to his late father, former Deputy Mayor Donald Kelly, and there is no doubt he had learned from his dad, David had grown into an effective and well respected politician in his own right.
"His heart was in everything he did."
Kelly was first elected in 1999 and has served on many committees and as deputy mayor.
In August, the council voted to name a new trail in honour of Kelly, who had pushed for its development for years. The David Kelly Trail stretches from Rainsford Park to Hanwell Road.
Kelly had been on a leave of absence to deal with the health issues related to his tumour.
Flags at City of Fredericton facilities will be lowered to half-mast until after the funeral, and a book of condolences will be set up at city hall until Friday.
Kelly leaves behind his wife Kim and their daughter Mallory.
(CKHJ, The Canadian Press)