The Phousi temple is on the Phousi mountain, the entrance stairway is at the entrance of the Luang Prabang Night Market
. It?s the best place to watch sunset at Luang Prabang
I?m not sure if you really need to pay the entree fee, but it was pretty cheap.
This map is from the entrance