Celebration Park is a nice place to spend the day but I have never spent the night there.  It is really hot in the summer without much shade.  There are a lot of activities there including hiking, swimming, fishing, the information center and atlatl throwing.  There are also petroglyphs in the area.